Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | StockMeter(AS_MTR_STK) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | Nozzle(AS_NZL) |
FuelingPointID (FK)(PK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | Nozzle(AS_NZL) |
NozzleID (FK)(PK) | A unique identifier for the Nozzle | ID_NZL | Identity | integer | Nozzle(AS_NZL) |
LocationID (FK)(PK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | InventoryLocation(LO_LCN_INV) |
StockMeterID (FK) | A unique identifier for the stock meter | ID_MTR_STK | Identity | integer | StockMeter(AS_MTR_STK) |
BlendPercentage | The percentage of the final blend that the given BULK ITEM constitutes. | PE_BLD | Percent | decimal(7,4) | |